﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_DispatchItemRegion') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_DispatchItemRegion
END
GO
create view V_DispatchItemRegion
as select 
[Guid]
,[ItemValue]
,[ItemCode]
,[DispatchMode]
,Code
from [ShopNum1_DispatchItemRegion] where IsDeleted=0